package net.knightwatch.kwtools.database;

import android.database.sqlite.SQLiteDatabase;
import android.util.Log;

public class BooleanQuestionTable {
	private static final String TAG = "BooleanQuestionTable";
	public static final String TABLE_BOOLEAN_QUESTIONS = "BooleanQuestions";
	public static final String COLUMN_ID = "_id";
	public static final String COLUMN_QUESTION_ID = "questionId";
	public static final String COLUMN_TRUE_TEXT	= "trueText";
	public static final String COLUMN_FALSE_TEXT = "falseText";
	public static final String COLUMN_DEFAULT_VALUE = "defaultValue";
	
	private static final String DATABASE_CREATE = "create table " 
			+ TABLE_BOOLEAN_QUESTIONS
			+ "("
			+ COLUMN_ID + " integer primary key autoincrement,"
			+ COLUMN_QUESTION_ID + " integer not null,"
			+ COLUMN_TRUE_TEXT + " text not null,"
			+ COLUMN_FALSE_TEXT + " text not null,"
			+ COLUMN_DEFAULT_VALUE + " boolean"
			+ ");";
	
	public static void onCreate(SQLiteDatabase database) {
		Log.i(TAG, DATABASE_CREATE);
		database.execSQL(DATABASE_CREATE);
	}
	
	
	public static void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion){
		
	}

}

